package com.acwer.drools.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.cache.annotation.CacheConfig;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Repository;

import com.acwer.drools.domain.ICD10YB;
import com.acwer.drools.domain.ICD9YB;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

//@CacheConfig(cacheNames="ICD9YBDao")
@Repository
//@Cacheable
public interface ICD9YBDao extends  BaseMapper<ICD9YB> {

	@Select({ "<script>", 
		"select * from icd9map", 
		"where ssbm in",
			"<foreach collection='list' open='(' close=')' item='id' index='i' separator=','>", "#{id}", "</foreach>",
			"</script>" 
		})
	public List<ICD9YB> selectJBYbBMByBM(List<String>ls);
	
	
	@Select({ "<script>", 
		"select * from icd9map", 
		"where ssbm =#{code}",
			"</script>" 
		})
	public ICD9YB selectSsYbBMByBM(String code);
}
